Dataset statistics
| Number of variables | 10 |
|---|---|
| Number of observations | 2722028 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 207.7 MiB |
| Average record size in memory | 80.0 B |
Variable types
| Numeric | 10 |
|---|
u is highly correlated with g and 8 other fields | High correlation |
g is highly correlated with u and 8 other fields | High correlation |
r is highly correlated with u and 8 other fields | High correlation |
i is highly correlated with u and 8 other fields | High correlation |
z is highly correlated with u and 8 other fields | High correlation |
uErr is highly correlated with u and 8 other fields | High correlation |
gErr is highly correlated with u and 8 other fields | High correlation |
rErr is highly correlated with u and 8 other fields | High correlation |
iErr is highly correlated with u and 8 other fields | High correlation |
zErr is highly correlated with u and 8 other fields | High correlation |
u is highly correlated with g and 8 other fields | High correlation |
g is highly correlated with u and 8 other fields | High correlation |
r is highly correlated with u and 8 other fields | High correlation |
i is highly correlated with u and 8 other fields | High correlation |
z is highly correlated with u and 8 other fields | High correlation |
uErr is highly correlated with u and 8 other fields | High correlation |
gErr is highly correlated with u and 8 other fields | High correlation |
rErr is highly correlated with u and 8 other fields | High correlation |
iErr is highly correlated with u and 8 other fields | High correlation |
zErr is highly correlated with u and 8 other fields | High correlation |
u is highly correlated with g and 4 other fields | High correlation |
g is highly correlated with u and 8 other fields | High correlation |
r is highly correlated with u and 7 other fields | High correlation |
i is highly correlated with g and 6 other fields | High correlation |
z is highly correlated with g and 6 other fields | High correlation |
uErr is highly correlated with u and 2 other fields | High correlation |
gErr is highly correlated with u and 8 other fields | High correlation |
rErr is highly correlated with u and 7 other fields | High correlation |
iErr is highly correlated with g and 6 other fields | High correlation |
zErr is highly correlated with g and 6 other fields | High correlation |
u is highly correlated with g and 8 other fields | High correlation |
g is highly correlated with u and 8 other fields | High correlation |
r is highly correlated with u and 8 other fields | High correlation |
i is highly correlated with u and 8 other fields | High correlation |
z is highly correlated with u and 8 other fields | High correlation |
uErr is highly correlated with u and 8 other fields | High correlation |
gErr is highly correlated with u and 8 other fields | High correlation |
rErr is highly correlated with u and 8 other fields | High correlation |
iErr is highly correlated with u and 8 other fields | High correlation |
zErr is highly correlated with u and 8 other fields | High correlation |
Reproduction
| Analysis started | 2022-02-27 19:55:04.700281 |
|---|---|
| Analysis finished | 2022-02-27 19:58:01.953629 |
| Duration | 2 minutes and 57.25 seconds |
| Software version | pandas-profiling v3.1.1 |
| Download configuration | config.json |
| Distinct | 855059 |
|---|---|
| Distinct (%) | 31.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.486448029 |
| Minimum | 3.390798359 |
|---|---|
| Maximum | 5.06395242 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.8 MiB |
Quantile statistics
| Minimum | 3.390798359 |
|---|---|
| 5-th percentile | 4.229034386 |
| Q1 | 4.367990055 |
| median | 4.510600884 |
| Q3 | 4.595010216 |
| 95-th percentile | 4.703141131 |
| Maximum | 5.06395242 |
| Range | 1.673154062 |
| Interquartile range (IQR) | 0.2270201612 |
Descriptive statistics
| Standard deviation | 0.1484141654 |
|---|---|
| Coefficient of variation (CV) | 0.03308054935 |
| Kurtosis | -0.5437861103 |
| Mean | 4.486448029 |
| Median Absolute Deviation (MAD) | 0.1026362228 |
| Skewness | -0.4255624828 |
| Sum | 12212237.15 |
| Variance | 0.0220267645 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4.622617655 | 362 | < 0.1% |
| 4.622618241 | 313 | < 0.1% |
| 4.622617069 | 254 | < 0.1% |
| 4.622618826 | 222 | < 0.1% |
| 4.622619412 | 101 | < 0.1% |
| 4.622619998 | 73 | < 0.1% |
| 4.622616484 | 70 | < 0.1% |
| 4.622620583 | 32 | < 0.1% |
| 4.622615898 | 24 | < 0.1% |
| 4.622621169 | 21 | < 0.1% |
| Other values (855049) | 2720556 |
| Value | Count | Frequency (%) |
| 3.390798359 | 1 | |
| 3.562678373 | 1 | |
| 3.700303211 | 1 | |
| 3.704106159 | 1 | |
| 3.780483338 | 1 | |
| 3.791529671 | 1 | |
| 3.830468305 | 1 | |
| 3.836884541 | 1 | |
| 3.845935587 | 1 | |
| 3.846507357 | 1 |
| Value | Count | Frequency (%) |
| 5.06395242 | 1 | |
| 5.029745724 | 1 | |
| 4.952333566 | 1 | |
| 4.945487848 | 1 | |
| 4.943917108 | 1 | |
| 4.943620382 | 1 | |
| 4.94300658 | 1 | |
| 4.942397677 | 1 | |
| 4.938646185 | 1 | |
| 4.935450318 | 1 |
| Distinct | 756885 |
|---|---|
| Distinct (%) | 27.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.372520689 |
| Minimum | 3.426885986 |
|---|---|
| Maximum | 5.040429572 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.8 MiB |
Quantile statistics
| Minimum | 3.426885986 |
|---|---|
| 5-th percentile | 4.10858831 |
| Q1 | 4.230409779 |
| median | 4.427266912 |
| Q3 | 4.485033897 |
| 95-th percentile | 4.553761674 |
| Maximum | 5.040429572 |
| Range | 1.613543586 |
| Interquartile range (IQR) | 0.2546241182 |
Descriptive statistics
| Standard deviation | 0.14998635 |
|---|---|
| Coefficient of variation (CV) | 0.03430203323 |
| Kurtosis | -0.5723558053 |
| Mean | 4.372520689 |
| Median Absolute Deviation (MAD) | 0.08125174785 |
| Skewness | -0.6558970419 |
| Sum | 11902123.75 |
| Variance | 0.02249590518 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4.650441754 | 104 | < 0.1% |
| 4.65044118 | 64 | < 0.1% |
| 4.650442329 | 54 | < 0.1% |
| 4.650442903 | 45 | < 0.1% |
| 4.476180759 | 25 | < 0.1% |
| 4.469219813 | 24 | < 0.1% |
| 4.461772131 | 24 | < 0.1% |
| 4.47448212 | 23 | < 0.1% |
| 4.467998692 | 23 | < 0.1% |
| 4.466948771 | 23 | < 0.1% |
| Other values (756875) | 2721619 |
| Value | Count | Frequency (%) |
| 3.426885986 | 1 | |
| 3.748952782 | 1 | |
| 3.762818652 | 1 | |
| 3.782573165 | 1 | |
| 3.792008848 | 1 | |
| 3.794965805 | 1 | |
| 3.80954924 | 1 | |
| 3.812980754 | 1 | |
| 3.815122466 | 1 | |
| 3.826034873 | 1 |
| Value | Count | Frequency (%) |
| 5.040429572 | 1 | |
| 4.985061362 | 1 | |
| 4.981954917 | 1 | |
| 4.9783398 | 1 | |
| 4.970585424 | 1 | |
| 4.969351292 | 1 | |
| 4.957272949 | 1 | |
| 4.952010601 | 1 | |
| 4.950840705 | 1 | |
| 4.950697958 | 1 |
| Distinct | 685409 |
|---|---|
| Distinct (%) | 25.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.278125623 |
| Minimum | 3.799572269 |
|---|---|
| Maximum | 4.52355882 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.8 MiB |
Quantile statistics
| Minimum | 3.799572269 |
|---|---|
| 5-th percentile | 4.039523017 |
| Q1 | 4.148581113 |
| median | 4.323320345 |
| Q3 | 4.384934637 |
| 95-th percentile | 4.459876163 |
| Maximum | 4.52355882 |
| Range | 0.7239865512 |
| Interquartile range (IQR) | 0.2363535237 |
Descriptive statistics
| Standard deviation | 0.1393037058 |
|---|---|
| Coefficient of variation (CV) | 0.03256185491 |
| Kurtosis | -0.6393827726 |
| Mean | 4.278125623 |
| Median Absolute Deviation (MAD) | 0.09464232507 |
| Skewness | -0.55434079 |
| Sum | 11645177.73 |
| Variance | 0.01940552245 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4.361115631 | 23 | < 0.1% |
| 4.367131995 | 22 | < 0.1% |
| 4.342728956 | 22 | < 0.1% |
| 4.357851069 | 22 | < 0.1% |
| 4.365724727 | 22 | < 0.1% |
| 4.377443773 | 22 | < 0.1% |
| 4.354011301 | 22 | < 0.1% |
| 4.359354599 | 22 | < 0.1% |
| 4.353086116 | 22 | < 0.1% |
| 4.361864489 | 21 | < 0.1% |
| Other values (685399) | 2721808 |
| Value | Count | Frequency (%) |
| 3.799572269 | 1 | |
| 3.799580557 | 1 | |
| 3.799589882 | 1 | |
| 3.799607495 | 1 | |
| 3.799611639 | 1 | |
| 3.799617855 | 1 | |
| 3.799639612 | 1 | |
| 3.799656188 | 1 | |
| 3.79967898 | 1 | |
| 3.799690376 | 1 |
| Value | Count | Frequency (%) |
| 4.52355882 | 1 | |
| 4.523557565 | 1 | |
| 4.523555683 | 1 | |
| 4.523543765 | 1 | |
| 4.523540002 | 1 | |
| 4.523536238 | 1 | |
| 4.523526829 | 1 | |
| 4.523524947 | 1 | |
| 4.523523065 | 1 | |
| 4.523506129 | 1 |
| Distinct | 675063 |
|---|---|
| Distinct (%) | 24.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.224445154 |
| Minimum | 3.064359504 |
|---|---|
| Maximum | 4.984258486 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.8 MiB |
Quantile statistics
| Minimum | 3.064359504 |
|---|---|
| 5-th percentile | 4.002581916 |
| Q1 | 4.112929445 |
| median | 4.258870887 |
| Q3 | 4.312862812 |
| 95-th percentile | 4.416755751 |
| Maximum | 4.984258486 |
| Range | 1.919898982 |
| Interquartile range (IQR) | 0.1999333672 |
Descriptive statistics
| Standard deviation | 0.1296779362 |
|---|---|
| Coefficient of variation (CV) | 0.03069703391 |
| Kurtosis | -0.3174942897 |
| Mean | 4.224445154 |
| Median Absolute Deviation (MAD) | 0.08356154249 |
| Skewness | -0.4564246975 |
| Sum | 11499057.99 |
| Variance | 0.01681636713 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4.606548827 | 74 | < 0.1% |
| 4.606549419 | 46 | < 0.1% |
| 4.303728153 | 27 | < 0.1% |
| 4.297738011 | 26 | < 0.1% |
| 4.293725817 | 26 | < 0.1% |
| 4.287102856 | 26 | < 0.1% |
| 4.288963127 | 25 | < 0.1% |
| 4.290257033 | 25 | < 0.1% |
| 4.293114414 | 25 | < 0.1% |
| 4.299418316 | 25 | < 0.1% |
| Other values (675053) | 2721703 |
| Value | Count | Frequency (%) |
| 3.064359504 | 1 | |
| 3.499453038 | 1 | |
| 3.58165735 | 1 | |
| 3.645071004 | 1 | |
| 3.702845901 | 1 | |
| 3.712312936 | 1 | |
| 3.712330547 | 1 | |
| 3.714130097 | 1 | |
| 3.722232114 | 1 | |
| 3.736021402 | 1 |
| Value | Count | Frequency (%) |
| 4.984258486 | 1 | |
| 4.964935961 | 1 | |
| 4.961151922 | 1 | |
| 4.957605881 | 1 | |
| 4.947025076 | 1 | |
| 4.946333643 | 1 | |
| 4.940685933 | 1 | |
| 4.937913542 | 1 | |
| 4.934338631 | 1 | |
| 4.930671587 | 1 |
| Distinct | 672835 |
|---|---|
| Distinct (%) | 24.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.193566506 |
| Minimum | 3.509876959 |
|---|---|
| Maximum | 4.907709814 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.8 MiB |
Quantile statistics
| Minimum | 3.509876959 |
|---|---|
| 5-th percentile | 3.973647411 |
| Q1 | 4.088367212 |
| median | 4.224172664 |
| Q3 | 4.278830781 |
| 95-th percentile | 4.397000633 |
| Maximum | 4.907709814 |
| Range | 1.397832855 |
| Interquartile range (IQR) | 0.1904635687 |
Descriptive statistics
| Standard deviation | 0.1290527713 |
|---|---|
| Coefficient of variation (CV) | 0.03077398942 |
| Kurtosis | -0.0705562617 |
| Mean | 4.193566506 |
| Median Absolute Deviation (MAD) | 0.0771778234 |
| Skewness | -0.3506220362 |
| Sum | 11415005.45 |
| Variance | 0.01665461778 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4.512663043 | 563 | < 0.1% |
| 4.512663675 | 328 | < 0.1% |
| 4.512662411 | 167 | < 0.1% |
| 4.512664307 | 88 | < 0.1% |
| 4.512664939 | 41 | < 0.1% |
| 4.512665571 | 31 | < 0.1% |
| 4.261477409 | 29 | < 0.1% |
| 4.264323239 | 28 | < 0.1% |
| 4.267044329 | 28 | < 0.1% |
| 4.28134662 | 27 | < 0.1% |
| Other values (672825) | 2720698 |
| Value | Count | Frequency (%) |
| 3.509876959 | 1 | |
| 3.630235376 | 1 | |
| 3.638523378 | 1 | |
| 3.677512752 | 1 | |
| 3.678114734 | 1 | |
| 3.690061686 | 1 | |
| 3.691627959 | 1 | |
| 3.692139255 | 1 | |
| 3.693017413 | 1 | |
| 3.695809012 | 1 |
| Value | Count | Frequency (%) |
| 4.907709814 | 1 | |
| 4.876946131 | 1 | |
| 4.871012677 | 1 | |
| 4.866615256 | 1 | |
| 4.859937256 | 1 | |
| 4.858945786 | 1 | |
| 4.856301517 | 1 | |
| 4.852765939 | 1 | |
| 4.851338783 | 1 | |
| 4.848929848 | 1 |
| Distinct | 2389824 |
|---|---|
| Distinct (%) | 87.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -1.434831639 |
| Minimum | -8.667876248 |
|---|---|
| Maximum | 5.539122821 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 2000773 |
| Negative (%) | 73.5% |
| Memory size | 20.8 MiB |
Quantile statistics
| Minimum | -8.667876248 |
|---|---|
| 5-th percentile | -4.869372974 |
| Q1 | -3.018550919 |
| median | -0.8567770501 |
| Q3 | 0.047874769 |
| 95-th percentile | 0.8304328913 |
| Maximum | 5.539122821 |
| Range | 14.20699907 |
| Interquartile range (IQR) | 3.066425688 |
Descriptive statistics
| Standard deviation | 1.877144742 |
|---|---|
| Coefficient of variation (CV) | -1.308268295 |
| Kurtosis | -0.6808896193 |
| Mean | -1.434831639 |
| Median Absolute Deviation (MAD) | 1.133982021 |
| Skewness | -0.6678040976 |
| Sum | -3905651.897 |
| Variance | 3.523672381 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.09729121102 | 8 | < 0.1% |
| 0.2040092151 | 8 | < 0.1% |
| 0.1847868152 | 8 | < 0.1% |
| 0.05744888581 | 8 | < 0.1% |
| 0.2343995374 | 8 | < 0.1% |
| 0.02657770786 | 8 | < 0.1% |
| 0.2732055352 | 8 | < 0.1% |
| 0.1088067792 | 7 | < 0.1% |
| 0.1621223632 | 7 | < 0.1% |
| 0.4266157902 | 7 | < 0.1% |
| Other values (2389814) | 2721951 |
| Value | Count | Frequency (%) |
| -8.667876248 | 1 | |
| -8.351582359 | 1 | |
| -8.201625847 | 1 | |
| -8.085729648 | 1 | |
| -7.985187871 | 1 | |
| -7.984592501 | 1 | |
| -7.962527113 | 1 | |
| -7.954996928 | 1 | |
| -7.92885058 | 1 | |
| -7.924510107 | 1 |
| Value | Count | Frequency (%) |
| 5.539122821 | 1 | |
| 5.255574377 | 1 | |
| 5.204707289 | 1 | |
| 4.819027411 | 1 | |
| 4.774580983 | 1 | |
| 4.754942537 | 1 | |
| 4.656721738 | 1 | |
| 4.466841127 | 1 | |
| 4.432548581 | 1 | |
| 4.39599778 | 1 |
| Distinct | 2357695 |
|---|---|
| Distinct (%) | 86.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -4.124869869 |
| Minimum | -9.072003501 |
|---|---|
| Maximum | 5.362660295 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 2707650 |
| Negative (%) | 99.5% |
| Memory size | 20.8 MiB |
Quantile statistics
| Minimum | -9.072003501 |
|---|---|
| 5-th percentile | -7.491407586 |
| Q1 | -6.275012705 |
| median | -3.509779691 |
| Q3 | -2.568363563 |
| 95-th percentile | -1.260035018 |
| Maximum | 5.362660295 |
| Range | 14.4346638 |
| Interquartile range (IQR) | 3.706649142 |
Descriptive statistics
| Standard deviation | 2.071773355 |
|---|---|
| Coefficient of variation (CV) | -0.502263931 |
| Kurtosis | -1.026591297 |
| Mean | -4.124869869 |
| Median Absolute Deviation (MAD) | 1.329614386 |
| Skewness | -0.3212671191 |
| Sum | -11228011.28 |
| Variance | 4.292244837 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -3.114672418 | 7 | < 0.1% |
| -2.913994575 | 7 | < 0.1% |
| -2.96368939 | 7 | < 0.1% |
| -2.962793794 | 7 | < 0.1% |
| -2.840472078 | 7 | < 0.1% |
| -3.211698502 | 7 | < 0.1% |
| -2.667114973 | 7 | < 0.1% |
| -2.728339113 | 7 | < 0.1% |
| -3.030398795 | 7 | < 0.1% |
| -3.083157129 | 7 | < 0.1% |
| Other values (2357685) | 2721958 |
| Value | Count | Frequency (%) |
| -9.072003501 | 1 | |
| -9.035906955 | 1 | |
| -8.979858395 | 1 | |
| -8.967981739 | 1 | |
| -8.953887953 | 1 | |
| -8.949457704 | 1 | |
| -8.943674315 | 1 | |
| -8.939130803 | 1 | |
| -8.932213277 | 1 | |
| -8.930604512 | 1 |
| Value | Count | Frequency (%) |
| 5.362660295 | 1 | |
| 4.800982189 | 1 | |
| 4.655533299 | 1 | |
| 4.222343214 | 1 | |
| 4.071263268 | 1 | |
| 3.841107645 | 1 | |
| 3.762277583 | 1 | |
| 3.621895971 | 1 | |
| 3.572610801 | 1 | |
| 3.366920852 | 1 |
| Distinct | 2464413 |
|---|---|
| Distinct (%) | 90.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -5.150489641 |
| Minimum | -9.057644664 |
|---|---|
| Maximum | -1.940751613 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 2722028 |
| Negative (%) | 100.0% |
| Memory size | 20.8 MiB |
Quantile statistics
| Minimum | -9.057644664 |
|---|---|
| 5-th percentile | -7.837512069 |
| Q1 | -6.861997212 |
| median | -4.764985311 |
| Q3 | -3.808233567 |
| 95-th percentile | -2.593715951 |
| Maximum | -1.940751613 |
| Range | 7.11689305 |
| Interquartile range (IQR) | 3.053763645 |
Descriptive statistics
| Standard deviation | 1.721509196 |
|---|---|
| Coefficient of variation (CV) | -0.3342418518 |
| Kurtosis | -1.162499474 |
| Mean | -5.150489641 |
| Median Absolute Deviation (MAD) | 1.371718401 |
| Skewness | -0.1795792286 |
| Sum | -14019777.02 |
| Variance | 2.96359391 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -3.277280783 | 6 | < 0.1% |
| -3.279654984 | 6 | < 0.1% |
| -3.308840359 | 6 | < 0.1% |
| -3.297109162 | 6 | < 0.1% |
| -3.278692794 | 6 | < 0.1% |
| -3.204460444 | 6 | < 0.1% |
| -2.889106552 | 6 | < 0.1% |
| -4.412563265 | 6 | < 0.1% |
| -2.967943179 | 6 | < 0.1% |
| -2.662258313 | 6 | < 0.1% |
| Other values (2464403) | 2721968 |
| Value | Count | Frequency (%) |
| -9.057644664 | 1 | |
| -9.055045484 | 1 | |
| -9.052046582 | 1 | |
| -9.048266982 | 1 | |
| -9.046312239 | 1 | |
| -9.046139104 | 1 | |
| -9.043696831 | 1 | |
| -9.04316549 | 1 | |
| -9.042214435 | 1 | |
| -9.041952054 | 1 |
| Value | Count | Frequency (%) |
| -1.940751613 | 1 | |
| -1.940756598 | 1 | |
| -1.940791492 | 2 | |
| -1.940794261 | 1 | |
| -1.940833587 | 1 | |
| -1.940857958 | 2 | |
| -1.940860727 | 1 | |
| -1.940883438 | 1 | |
| -1.940892854 | 1 | |
| -1.940893408 | 1 |
| Distinct | 2416685 |
|---|---|
| Distinct (%) | 88.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -5.481338672 |
| Minimum | -17.86008046 |
|---|---|
| Maximum | 4.809064533 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 2721423 |
| Negative (%) | > 99.9% |
| Memory size | 20.8 MiB |
Quantile statistics
| Minimum | -17.86008046 |
|---|---|
| 5-th percentile | -7.833942927 |
| Q1 | -6.854766832 |
| median | -5.230101275 |
| Q3 | -4.488836745 |
| 95-th percentile | -2.977489689 |
| Maximum | 4.809064533 |
| Range | 22.669145 |
| Interquartile range (IQR) | 2.365930086 |
Descriptive statistics
| Standard deviation | 1.510037138 |
|---|---|
| Coefficient of variation (CV) | -0.2754869254 |
| Kurtosis | -0.6308609877 |
| Mean | -5.481338672 |
| Median Absolute Deviation (MAD) | 1.081586949 |
| Skewness | 0.03016363378 |
| Sum | -14920357.34 |
| Variance | 2.280212158 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -5.088663374 | 7 | < 0.1% |
| -6.506583516 | 6 | < 0.1% |
| -4.874601967 | 6 | < 0.1% |
| -6.601315506 | 6 | < 0.1% |
| -6.574001445 | 6 | < 0.1% |
| -5.726060894 | 6 | < 0.1% |
| -6.464406288 | 6 | < 0.1% |
| -5.132111378 | 6 | < 0.1% |
| -6.578547213 | 6 | < 0.1% |
| -5.263488568 | 6 | < 0.1% |
| Other values (2416675) | 2721967 |
| Value | Count | Frequency (%) |
| -17.86008046 | 1 | |
| -9.70503716 | 1 | |
| -9.641853965 | 1 | |
| -9.407273691 | 1 | |
| -9.090525573 | 1 | |
| -9.079114747 | 1 | |
| -9.070516568 | 1 | |
| -9.066550638 | 1 | |
| -9.065812104 | 1 | |
| -9.064262026 | 1 |
| Value | Count | Frequency (%) |
| 4.809064533 | 1 | |
| 4.372220121 | 1 | |
| 4.251874335 | 1 | |
| 4.0618168 | 1 | |
| 4.058777115 | 1 | |
| 3.846400042 | 1 | |
| 3.844672878 | 1 | |
| 3.800264198 | 1 | |
| 3.700192219 | 1 | |
| 3.599098754 | 1 |
| Distinct | 2355495 |
|---|---|
| Distinct (%) | 86.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -4.197201727 |
| Minimum | -11.04430682 |
|---|---|
| Maximum | 5.428461681 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 2714354 |
| Negative (%) | 99.7% |
| Memory size | 20.8 MiB |
Quantile statistics
| Minimum | -11.04430682 |
|---|---|
| 5-th percentile | -6.741076826 |
| Q1 | -5.486915348 |
| median | -3.939197105 |
| Q3 | -3.184987004 |
| 95-th percentile | -1.540930874 |
| Maximum | 5.428461681 |
| Range | 16.4727685 |
| Interquartile range (IQR) | 2.301928344 |
Descriptive statistics
| Standard deviation | 1.573221656 |
|---|---|
| Coefficient of variation (CV) | -0.3748263148 |
| Kurtosis | -0.3108389625 |
| Mean | -4.197201727 |
| Median Absolute Deviation (MAD) | 1.025748282 |
| Skewness | 0.0048595915 |
| Sum | -11424900.62 |
| Variance | 2.475026378 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -3.225655445 | 9 | < 0.1% |
| -3.295949632 | 8 | < 0.1% |
| -3.062972659 | 8 | < 0.1% |
| -3.263126741 | 8 | < 0.1% |
| -3.267678348 | 8 | < 0.1% |
| -3.073907037 | 8 | < 0.1% |
| -3.224167643 | 8 | < 0.1% |
| -3.22527222 | 8 | < 0.1% |
| -3.263944168 | 8 | < 0.1% |
| -3.166662 | 7 | < 0.1% |
| Other values (2355485) | 2721948 |
| Value | Count | Frequency (%) |
| -11.04430682 | 1 | |
| -8.74056304 | 1 | |
| -8.675703786 | 1 | |
| -8.659347625 | 1 | |
| -8.638934041 | 1 | |
| -8.623772928 | 1 | |
| -8.622905311 | 1 | |
| -8.62179268 | 1 | |
| -8.617825584 | 1 | |
| -8.602027836 | 1 |
| Value | Count | Frequency (%) |
| 5.428461681 | 1 | |
| 5.154627357 | 1 | |
| 4.83715257 | 1 | |
| 4.659680284 | 1 | |
| 4.535170223 | 1 | |
| 4.52112865 | 1 | |
| 4.516786102 | 1 | |
| 4.496352411 | 1 | |
| 4.480212119 | 1 | |
| 4.410316001 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| u | g | r | i | z | uErr | gErr | rErr | iErr | zErr | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 4.626528 | 4.479334 | 4.442595 | 4.419593 | 4.421121 | -0.355339 | -3.336726 | -3.676320 | -3.601732 | -2.054881 |
| 1 | 4.502965 | 4.457257 | 4.456083 | 4.441204 | 4.450291 | -1.355431 | -3.687659 | -2.956998 | -2.538448 | -0.822430 |
| 2 | 4.710716 | 4.486403 | 4.436536 | 4.431192 | 4.452598 | -1.429789 | -3.167303 | -3.649887 | -3.269892 | -1.010986 |
| 3 | 4.620863 | 4.451050 | 4.436583 | 4.435823 | 4.471525 | -0.274045 | -4.040311 | -3.937535 | -3.320107 | -0.977932 |
| 4 | 4.650859 | 4.510959 | 4.473232 | 4.449842 | 4.466110 | -0.552079 | -2.900234 | -3.169031 | -3.157272 | -1.057521 |
| 5 | 4.590488 | 4.514341 | 4.479465 | 4.462569 | 4.485609 | -0.638633 | -2.954404 | -3.008676 | -2.879989 | -0.917506 |
| 6 | 4.595464 | 4.746502 | 4.331912 | 4.226999 | 4.397498 | 1.355257 | -0.565750 | -4.021652 | -4.051302 | -0.188940 |
| 7 | 4.446422 | 4.375726 | 4.337387 | 4.331816 | 4.336153 | -2.851058 | -4.968574 | -5.292891 | -4.964696 | -3.101935 |
| 8 | 4.661150 | 4.457774 | 4.409656 | 4.403341 | 4.403371 | -0.632070 | -3.664285 | -4.244816 | -3.885261 | -2.226197 |
| 9 | 4.587799 | 4.469868 | 4.439136 | 4.434172 | 4.432422 | -0.861786 | -3.688879 | -3.702853 | -3.295795 | -1.719452 |
Last rows
| u | g | r | i | z | uErr | gErr | rErr | iErr | zErr | |
|---|---|---|---|---|---|---|---|---|---|---|
| 2722018 | 4.527239 | 4.482957 | 4.428479 | 4.400312 | 4.344791 | -0.732971 | -2.869584 | -3.060388 | -3.138966 | -2.158918 |
| 2722019 | 4.440556 | 4.417676 | 4.387888 | 4.372629 | 4.353696 | -2.992044 | -4.598663 | -4.621510 | -4.415295 | -3.147767 |
| 2722020 | 4.633763 | 4.532246 | 4.428964 | 4.344044 | 4.276367 | 1.520788 | -0.775378 | -2.303812 | -3.334496 | -2.704285 |
| 2722021 | 4.317052 | 4.293955 | 4.280261 | 4.282380 | 4.273097 | -4.661460 | -6.264825 | -6.204331 | -5.687643 | -4.180041 |
| 2722022 | 4.327511 | 4.297402 | 4.293443 | 4.295464 | 4.328839 | -4.160500 | -6.102440 | -5.669864 | -5.200289 | -2.618014 |
| 2722023 | 4.439152 | 4.446434 | 4.417884 | 4.417204 | 4.426794 | -2.282216 | -3.449858 | -3.192773 | -2.606672 | -0.754991 |
| 2722024 | 4.401188 | 4.413862 | 4.425684 | 4.405132 | 4.390952 | -3.287110 | -4.154399 | -3.488137 | -3.296911 | -1.689056 |
| 2722025 | 4.464462 | 4.446029 | 4.425365 | 4.419637 | 4.381432 | -2.106479 | -4.136353 | -3.711797 | -3.317333 | -1.921612 |
| 2722026 | 4.410477 | 4.375687 | 4.362548 | 4.352096 | 4.359427 | -3.544141 | -5.336474 | -5.141721 | -4.889821 | -3.045029 |
| 2722027 | 4.497682 | 4.410842 | 4.380036 | 4.365697 | 4.365682 | -1.708628 | -4.375056 | -4.451421 | -4.167061 | -2.168564 |